package com.lifesea.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MedReferralFeeCompensationExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MedReferralFeeCompensationExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andReferralIdIsNull() {
            addCriterion("referral_id is null");
            return (Criteria) this;
        }

        public Criteria andReferralIdIsNotNull() {
            addCriterion("referral_id is not null");
            return (Criteria) this;
        }

        public Criteria andReferralIdEqualTo(String value) {
            addCriterion("referral_id =", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotEqualTo(String value) {
            addCriterion("referral_id <>", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdGreaterThan(String value) {
            addCriterion("referral_id >", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdGreaterThanOrEqualTo(String value) {
            addCriterion("referral_id >=", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdLessThan(String value) {
            addCriterion("referral_id <", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdLessThanOrEqualTo(String value) {
            addCriterion("referral_id <=", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdLike(String value) {
            addCriterion("referral_id like", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotLike(String value) {
            addCriterion("referral_id not like", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdIn(List<String> values) {
            addCriterion("referral_id in", values, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotIn(List<String> values) {
            addCriterion("referral_id not in", values, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdBetween(String value1, String value2) {
            addCriterion("referral_id between", value1, value2, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotBetween(String value1, String value2) {
            addCriterion("referral_id not between", value1, value2, "referralId");
            return (Criteria) this;
        }

        public Criteria andZydjlshIsNull() {
            addCriterion("zydjlsh is null");
            return (Criteria) this;
        }

        public Criteria andZydjlshIsNotNull() {
            addCriterion("zydjlsh is not null");
            return (Criteria) this;
        }

        public Criteria andZydjlshEqualTo(String value) {
            addCriterion("zydjlsh =", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshNotEqualTo(String value) {
            addCriterion("zydjlsh <>", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshGreaterThan(String value) {
            addCriterion("zydjlsh >", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshGreaterThanOrEqualTo(String value) {
            addCriterion("zydjlsh >=", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshLessThan(String value) {
            addCriterion("zydjlsh <", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshLessThanOrEqualTo(String value) {
            addCriterion("zydjlsh <=", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshLike(String value) {
            addCriterion("zydjlsh like", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshNotLike(String value) {
            addCriterion("zydjlsh not like", value, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshIn(List<String> values) {
            addCriterion("zydjlsh in", values, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshNotIn(List<String> values) {
            addCriterion("zydjlsh not in", values, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshBetween(String value1, String value2) {
            addCriterion("zydjlsh between", value1, value2, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andZydjlshNotBetween(String value1, String value2) {
            addCriterion("zydjlsh not between", value1, value2, "zydjlsh");
            return (Criteria) this;
        }

        public Criteria andKbczyyfIsNull() {
            addCriterion("kbczyyf is null");
            return (Criteria) this;
        }

        public Criteria andKbczyyfIsNotNull() {
            addCriterion("kbczyyf is not null");
            return (Criteria) this;
        }

        public Criteria andKbczyyfEqualTo(BigDecimal value) {
            addCriterion("kbczyyf =", value, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfNotEqualTo(BigDecimal value) {
            addCriterion("kbczyyf <>", value, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfGreaterThan(BigDecimal value) {
            addCriterion("kbczyyf >", value, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("kbczyyf >=", value, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfLessThan(BigDecimal value) {
            addCriterion("kbczyyf <", value, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfLessThanOrEqualTo(BigDecimal value) {
            addCriterion("kbczyyf <=", value, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfIn(List<BigDecimal> values) {
            addCriterion("kbczyyf in", values, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfNotIn(List<BigDecimal> values) {
            addCriterion("kbczyyf not in", values, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("kbczyyf between", value1, value2, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyyfNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("kbczyyf not between", value1, value2, "kbczyyf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfIsNull() {
            addCriterion("kbczyylf is null");
            return (Criteria) this;
        }

        public Criteria andKbczyylfIsNotNull() {
            addCriterion("kbczyylf is not null");
            return (Criteria) this;
        }

        public Criteria andKbczyylfEqualTo(BigDecimal value) {
            addCriterion("kbczyylf =", value, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfNotEqualTo(BigDecimal value) {
            addCriterion("kbczyylf <>", value, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfGreaterThan(BigDecimal value) {
            addCriterion("kbczyylf >", value, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("kbczyylf >=", value, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfLessThan(BigDecimal value) {
            addCriterion("kbczyylf <", value, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfLessThanOrEqualTo(BigDecimal value) {
            addCriterion("kbczyylf <=", value, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfIn(List<BigDecimal> values) {
            addCriterion("kbczyylf in", values, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfNotIn(List<BigDecimal> values) {
            addCriterion("kbczyylf not in", values, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("kbczyylf between", value1, value2, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andKbczyylfNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("kbczyylf not between", value1, value2, "kbczyylf");
            return (Criteria) this;
        }

        public Criteria andHsbcjeIsNull() {
            addCriterion("hsbcje is null");
            return (Criteria) this;
        }

        public Criteria andHsbcjeIsNotNull() {
            addCriterion("hsbcje is not null");
            return (Criteria) this;
        }

        public Criteria andHsbcjeEqualTo(BigDecimal value) {
            addCriterion("hsbcje =", value, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeNotEqualTo(BigDecimal value) {
            addCriterion("hsbcje <>", value, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeGreaterThan(BigDecimal value) {
            addCriterion("hsbcje >", value, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("hsbcje >=", value, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeLessThan(BigDecimal value) {
            addCriterion("hsbcje <", value, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("hsbcje <=", value, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeIn(List<BigDecimal> values) {
            addCriterion("hsbcje in", values, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeNotIn(List<BigDecimal> values) {
            addCriterion("hsbcje not in", values, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("hsbcje between", value1, value2, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andHsbcjeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("hsbcje not between", value1, value2, "hsbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeIsNull() {
            addCriterion("sjbcje is null");
            return (Criteria) this;
        }

        public Criteria andSjbcjeIsNotNull() {
            addCriterion("sjbcje is not null");
            return (Criteria) this;
        }

        public Criteria andSjbcjeEqualTo(BigDecimal value) {
            addCriterion("sjbcje =", value, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeNotEqualTo(BigDecimal value) {
            addCriterion("sjbcje <>", value, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeGreaterThan(BigDecimal value) {
            addCriterion("sjbcje >", value, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sjbcje >=", value, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeLessThan(BigDecimal value) {
            addCriterion("sjbcje <", value, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sjbcje <=", value, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeIn(List<BigDecimal> values) {
            addCriterion("sjbcje in", values, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeNotIn(List<BigDecimal> values) {
            addCriterion("sjbcje not in", values, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sjbcje between", value1, value2, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andSjbcjeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sjbcje not between", value1, value2, "sjbcje");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxIsNull() {
            addCriterion("yjsqksmxx is null");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxIsNotNull() {
            addCriterion("yjsqksmxx is not null");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxEqualTo(String value) {
            addCriterion("yjsqksmxx =", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxNotEqualTo(String value) {
            addCriterion("yjsqksmxx <>", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxGreaterThan(String value) {
            addCriterion("yjsqksmxx >", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxGreaterThanOrEqualTo(String value) {
            addCriterion("yjsqksmxx >=", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxLessThan(String value) {
            addCriterion("yjsqksmxx <", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxLessThanOrEqualTo(String value) {
            addCriterion("yjsqksmxx <=", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxLike(String value) {
            addCriterion("yjsqksmxx like", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxNotLike(String value) {
            addCriterion("yjsqksmxx not like", value, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxIn(List<String> values) {
            addCriterion("yjsqksmxx in", values, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxNotIn(List<String> values) {
            addCriterion("yjsqksmxx not in", values, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxBetween(String value1, String value2) {
            addCriterion("yjsqksmxx between", value1, value2, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andYjsqksmxxNotBetween(String value1, String value2) {
            addCriterion("yjsqksmxx not between", value1, value2, "yjsqksmxx");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeIsNull() {
            addCriterion("xnhbxze is null");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeIsNotNull() {
            addCriterion("xnhbxze is not null");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeEqualTo(BigDecimal value) {
            addCriterion("xnhbxze =", value, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeNotEqualTo(BigDecimal value) {
            addCriterion("xnhbxze <>", value, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeGreaterThan(BigDecimal value) {
            addCriterion("xnhbxze >", value, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("xnhbxze >=", value, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeLessThan(BigDecimal value) {
            addCriterion("xnhbxze <", value, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("xnhbxze <=", value, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeIn(List<BigDecimal> values) {
            addCriterion("xnhbxze in", values, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeNotIn(List<BigDecimal> values) {
            addCriterion("xnhbxze not in", values, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("xnhbxze between", value1, value2, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andXnhbxzeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("xnhbxze not between", value1, value2, "xnhbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeIsNull() {
            addCriterion("dbbxbxze is null");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeIsNotNull() {
            addCriterion("dbbxbxze is not null");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeEqualTo(BigDecimal value) {
            addCriterion("dbbxbxze =", value, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeNotEqualTo(BigDecimal value) {
            addCriterion("dbbxbxze <>", value, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeGreaterThan(BigDecimal value) {
            addCriterion("dbbxbxze >", value, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("dbbxbxze >=", value, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeLessThan(BigDecimal value) {
            addCriterion("dbbxbxze <", value, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("dbbxbxze <=", value, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeIn(List<BigDecimal> values) {
            addCriterion("dbbxbxze in", values, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeNotIn(List<BigDecimal> values) {
            addCriterion("dbbxbxze not in", values, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dbbxbxze between", value1, value2, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxbxzeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dbbxbxze not between", value1, value2, "dbbxbxze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeIsNull() {
            addCriterion("dbbxkbze is null");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeIsNotNull() {
            addCriterion("dbbxkbze is not null");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeEqualTo(BigDecimal value) {
            addCriterion("dbbxkbze =", value, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeNotEqualTo(BigDecimal value) {
            addCriterion("dbbxkbze <>", value, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeGreaterThan(BigDecimal value) {
            addCriterion("dbbxkbze >", value, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("dbbxkbze >=", value, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeLessThan(BigDecimal value) {
            addCriterion("dbbxkbze <", value, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("dbbxkbze <=", value, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeIn(List<BigDecimal> values) {
            addCriterion("dbbxkbze in", values, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeNotIn(List<BigDecimal> values) {
            addCriterion("dbbxkbze not in", values, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dbbxkbze between", value1, value2, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andDbbxkbzeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dbbxkbze not between", value1, value2, "dbbxkbze");
            return (Criteria) this;
        }

        public Criteria andBczcIsNull() {
            addCriterion("bczc is null");
            return (Criteria) this;
        }

        public Criteria andBczcIsNotNull() {
            addCriterion("bczc is not null");
            return (Criteria) this;
        }

        public Criteria andBczcEqualTo(String value) {
            addCriterion("bczc =", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcNotEqualTo(String value) {
            addCriterion("bczc <>", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcGreaterThan(String value) {
            addCriterion("bczc >", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcGreaterThanOrEqualTo(String value) {
            addCriterion("bczc >=", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcLessThan(String value) {
            addCriterion("bczc <", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcLessThanOrEqualTo(String value) {
            addCriterion("bczc <=", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcLike(String value) {
            addCriterion("bczc like", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcNotLike(String value) {
            addCriterion("bczc not like", value, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcIn(List<String> values) {
            addCriterion("bczc in", values, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcNotIn(List<String> values) {
            addCriterion("bczc not in", values, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcBetween(String value1, String value2) {
            addCriterion("bczc between", value1, value2, "bczc");
            return (Criteria) this;
        }

        public Criteria andBczcNotBetween(String value1, String value2) {
            addCriterion("bczc not between", value1, value2, "bczc");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyIsNull() {
            addCriterion("mzjzbcfy is null");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyIsNotNull() {
            addCriterion("mzjzbcfy is not null");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyEqualTo(BigDecimal value) {
            addCriterion("mzjzbcfy =", value, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyNotEqualTo(BigDecimal value) {
            addCriterion("mzjzbcfy <>", value, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyGreaterThan(BigDecimal value) {
            addCriterion("mzjzbcfy >", value, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("mzjzbcfy >=", value, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyLessThan(BigDecimal value) {
            addCriterion("mzjzbcfy <", value, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("mzjzbcfy <=", value, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyIn(List<BigDecimal> values) {
            addCriterion("mzjzbcfy in", values, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyNotIn(List<BigDecimal> values) {
            addCriterion("mzjzbcfy not in", values, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("mzjzbcfy between", value1, value2, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andMzjzbcfyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("mzjzbcfy not between", value1, value2, "mzjzbcfy");
            return (Criteria) this;
        }

        public Criteria andInsertdateIsNull() {
            addCriterion("insertdate is null");
            return (Criteria) this;
        }

        public Criteria andInsertdateIsNotNull() {
            addCriterion("insertdate is not null");
            return (Criteria) this;
        }

        public Criteria andInsertdateEqualTo(Date value) {
            addCriterion("insertdate =", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateNotEqualTo(Date value) {
            addCriterion("insertdate <>", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateGreaterThan(Date value) {
            addCriterion("insertdate >", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateGreaterThanOrEqualTo(Date value) {
            addCriterion("insertdate >=", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateLessThan(Date value) {
            addCriterion("insertdate <", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateLessThanOrEqualTo(Date value) {
            addCriterion("insertdate <=", value, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateIn(List<Date> values) {
            addCriterion("insertdate in", values, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateNotIn(List<Date> values) {
            addCriterion("insertdate not in", values, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateBetween(Date value1, Date value2) {
            addCriterion("insertdate between", value1, value2, "insertdate");
            return (Criteria) this;
        }

        public Criteria andInsertdateNotBetween(Date value1, Date value2) {
            addCriterion("insertdate not between", value1, value2, "insertdate");
            return (Criteria) this;
        }

        public Criteria andZyzfyIsNull() {
            addCriterion("zyzfy is null");
            return (Criteria) this;
        }

        public Criteria andZyzfyIsNotNull() {
            addCriterion("zyzfy is not null");
            return (Criteria) this;
        }

        public Criteria andZyzfyEqualTo(BigDecimal value) {
            addCriterion("zyzfy =", value, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyNotEqualTo(BigDecimal value) {
            addCriterion("zyzfy <>", value, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyGreaterThan(BigDecimal value) {
            addCriterion("zyzfy >", value, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("zyzfy >=", value, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyLessThan(BigDecimal value) {
            addCriterion("zyzfy <", value, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("zyzfy <=", value, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyIn(List<BigDecimal> values) {
            addCriterion("zyzfy in", values, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyNotIn(List<BigDecimal> values) {
            addCriterion("zyzfy not in", values, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("zyzfy between", value1, value2, "zyzfy");
            return (Criteria) this;
        }

        public Criteria andZyzfyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("zyzfy not between", value1, value2, "zyzfy");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table med_referral_fee_compensation
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}